SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO






CREATE PROCEDURE [dbo].[usp_AddNewRequire]
      (
        @JOL_Require_Company VARCHAR(50) ,
        @JOL_Require_Job VARCHAR(50) ,
        @JOL_Require_Work_Area VARCHAR(50) ,
        @JOL_Require_Study_Level VARCHAR(50) ,
        @JOL_Require_Profession VARCHAR(50) ,
        @JOL_Require_Number INT ,
        @JOL_Require_GetJob_Type VARCHAR(50) ,
        @JOL_Require_Linkman VARCHAR(50) ,
        @JOL_Require_Contact VARCHAR(50) ,
        @JOL_Require_EndTime DATETIME ,
        @JOL_Require_Requirement NTEXT ,
        @JOL_Require_Remark NTEXT ,
        @JOL_Require_AddUser VARCHAR(50) ,
        @JOL_Require_AddTime DATETIME ,
        @JOL_Require_Student_Type INT ,
        @JOL_Require_VerifyTime DATETIME ,
        @JOL_Require_VerifyUser VARCHAR(50) ,
        @JOL_Require_VerifyStatus VARCHAR(50) ,
        @OnlyForSysu BIT
      )
AS 
      INSERT    INTO dbo.JOL_Require
                (
                  JOL_Require_Company ,
                  JOL_Require_Job ,
                  JOL_Require_Work_Area ,
                  JOL_Require_Study_Level ,
                  JOL_Require_Profession ,
                  JOL_Require_Number ,
                  JOL_Require_GetJob_Type ,
                  JOL_Require_Linkman ,
                  JOL_Require_Contact ,
                  JOL_Require_EndTime ,
                  JOL_Require_Requirement ,
                  JOL_Require_Remark ,
                  JOL_Require_AddUser ,
                  JOL_Require_AddTime ,
                  JOL_Require_UpdateTime ,
                  JOL_Require_UpdateUser ,
                  JOL_Require_VerifyTime ,
                  JOL_Require_VerifyStatus ,
                  JOL_Require_VerifyUser ,
                  JOL_Require_IsSendEmail ,
                  JOL_Require_Student_Type ,
                  JOL_Require_ClickNumber ,
                  OnlyForSysu
                
                )
      VALUES    (
                  @JOL_Require_Company , -- JOL_Require_Company - varchar(50)
                  @JOL_Require_Job , -- JOL_Require_Job - varchar(50)
                  @JOL_Require_Work_Area , -- JOL_Require_Work_Area - varchar(50)
                  @JOL_Require_Study_Level , -- JOL_Require_Study_Level - varchar(50)
                  @JOL_Require_Profession , -- JOL_Require_Profession - varchar(50)
                  @JOL_Require_Number , -- JOL_Require_Number - int
                  @JOL_Require_GetJob_Type , -- JOL_Require_GetJob_Type - varchar(50)
                  @JOL_Require_Linkman , -- JOL_Require_Linkman - varchar(50)
                  @JOL_Require_Contact , -- JOL_Require_Contact - varchar(50)
                  @JOL_Require_EndTime , -- JOL_Require_EndTime - datetime
                  @JOL_Require_Requirement , -- JOL_Require_Requirement - ntext
                  @JOL_Require_Remark , -- JOL_Require_Remark - ntext
                  @JOL_Require_AddUser , -- JOL_Require_AddUser - varchar(50)
                  GETDATE() , -- JOL_Require_AddTime - datetime
                  NULL , -- JOL_Require_UpdateTime - datetime
                  NULL , -- JOL_Require_UpdateUser - varchar(50)
                  @JOL_Require_VerifyTime , -- JOL_Require_VerifyTime - datetime
                  @JOL_Require_VerifyStatus , -- JOL_Require_VerifyStatus - varchar(5)
                  @JOL_Require_VerifyUser , -- JOL_Require_VerifyUser - varchar(50)
                  NULL , -- JOL_Require_IsSendEmail - bit
                  @JOL_Require_Student_Type , -- JOL_Require_Student_Type - int
                  0 , -- JOL_Require_ClickNumber - int
                  @OnlyForSysu  
                )





GO
